﻿CREATE TABLE [dbo].[User]
(
	[UserId] INT IDENTITY (1,1) NOT NULL,
    [Name] NVARCHAR(64) NOT NULL,
    [Email] NVARCHAR(256) NOT NULL,
    [CreatedBy] NVARCHAR (256) NOT NULL,
    [CreateDate] DATETIME NOT NULL,
    [ModifiedBy] NVARCHAR (256) NOT NULL,
    [ModifyDate] DATETIME NOT NULL,
    CONSTRAINT [PkUser] PRIMARY KEY CLUSTERED ([UserId])
)
go
create unique index UX_User_Name on dbo.[User] ([Name])
go
create unique index UX_User_Email on dbo.[User] ([Email])
go

